<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
  <comment>DDL statements for user database</comment>
  <entry key="check.table">user_props</entry>
  <entry key="users.create">
	create table users(name varchar(128) not null,password varchar(254), enabled char(1) not null, primary key(name))   ENGINE=InnoDB
  </entry>
  <entry key="userprops.create">
	create table user_props(username varchar(128) not null,propname varchar(64) not null, propvalue varchar(2048),primary key (username,propname)) ENGINE=InnoDB
  </entry>

  <entry key="groups.create">
	create table groups(name varchar(128) not null, enabled char(1) not null, primary key(name)) ENGINE=InnoDB
  </entry>
  <entry key="groupmembers.create">
	create table group_members(groupname varchar(128) not null, username varchar(128) not null, primary key(groupname,username)) ENGINE=InnoDB
  </entry>
  <entry key="groupmembers.indexcreate">
	create index group_members_idx on group_members(username,groupname)
  </entry>

  <entry key="users.drop">drop table users</entry>
  <entry key="userprops.drop">drop table user_props</entry>
  <entry key="groups.drop">drop table groups</entry>
  <entry key="groupmembers.drop">drop table group_members</entry>
  
  <!-- since GeoServer version 2.3.0 -->  
  <entry key="userprops.indexcreate1">
	create index user_props_idx1 on user_props(propname,propvalue)
  </entry>  
    <entry key="userprops.indexcreate2">
	create index user_props_idx2 on user_props(propname,username)
  </entry>
  <!--  end GeoServer version 2.3.0 -->
	  
</properties>
